Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	20279
Missing cells	12956
Missing cells (%)	3.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.3 MiB
Average record size in memory	480.6 B

Variable types

NUM	11
CAT	5
BOOL	1

Reproduction

Analysis started	2020-05-20 15:47:39.520144
Analysis finished	2020-05-20 15:48:33.955742
Version	pandas-profiling v2.5.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`gift_id` has a high cardinality: 20279 distinct values	High cardinality
`instock_date` has a high cardinality: 17147 distinct values	High cardinality
`stock_update_date` has a high cardinality: 14794 distinct values	High cardinality
`uk_date1` has a high cardinality: 16384 distinct values	High cardinality
`uk_date2` has a high cardinality: 7210 distinct values	High cardinality
`volumes` has 12956 (63.9%) missing values	Missing
`instock_date` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`stock_update_date` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`uk_date1` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`uk_date2` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`gift_cluster` has 3568 (17.6%) zeros	Zeros

gift_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct count	20279
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	158.6 KiB

GF_15330	1
GF_14569	1
GF_19303	1
GF_20189	1
GF_11946	1
Other values (20274)	20274

Value	Count	Frequency (%)
GF_15330	1	< 0.1%
GF_14569	1	< 0.1%
GF_19303	1	< 0.1%
GF_20189	1	< 0.1%
GF_11946	1	< 0.1%
GF_19220	1	< 0.1%
GF_13718	1	< 0.1%
GF_24271	1	< 0.1%
GF_10883	1	< 0.1%
GF_18968	1	< 0.1%
Other values (20269)	20269	> 99.9%

Length

Max length	8
Mean length	7.559593668
Min length	4

Value	Count	Frequency (%)
Decimal_Number	10	76.9%
Uppercase_Letter	2	15.4%
Connector_Punctuation	1	7.7%

Value	Count	Frequency (%)
Common	11	84.6%
Latin	2	15.4%

Value	Count	Frequency (%)
ASCII	13	100.0%

gift_type
Real number (ℝ_≥0)

Distinct count	1237
Unique (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	739.5546625
Minimum	1
Maximum	1360
Zeros	0
Zeros (%)	0.0%
Memory size	158.6 KiB

Quantile statistics

Minimum	1
5-th percentile	66
Q1	403
median	825
Q3	1032
95-th percentile	1271
Maximum	1360
Range	1359
Interquartile range (IQR)	629

Descriptive statistics

Standard deviation	389.2169888
Coefficient of variation (CV)	0.5262856264
Kurtosis	-1.148934749
Mean	739.5546625
Median Absolute Deviation (MAD)	339.8746067
Skewness	-0.2776329907
Sum	14997429
Variance	151489.8643

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.0000e+00 4.0000e+00 9.5000e+00 1.1500e+01 1.7500e+01 ... 1.3135e+03 1.3145e+03 1.3155e+03 1.3375e+03 1.3600e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1008	988	4.9%
1266	982	4.8%
660	889	4.4%
992	550	2.7%
896	493	2.4%
908	376	1.9%
1173	355	1.8%
415	347	1.7%
1111	318	1.6%
899	297	1.5%
Other values (1227)	14684	72.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	< 0.1%
2	3	< 0.1%
3	19	0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
1360	1	< 0.1%
1357	2	< 0.1%
1356	2	< 0.1%
1355	5	< 0.1%
1354	6	< 0.1%

gift_category
Real number (ℝ_≥0)

Distinct count	852
Unique (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	394.1715568
Minimum	1
Maximum	893
Zeros	0
Zeros (%)	0.0%
Memory size	158.6 KiB

Quantile statistics

Minimum	1
5-th percentile	38
Q1	188
median	433
Q3	534
95-th percentile	815
Maximum	893
Range	892
Interquartile range (IQR)	346

Descriptive statistics

Standard deviation	235.0777687
Coefficient of variation (CV)	0.5963844035
Kurtosis	-0.9591278385
Mean	394.1715568
Median Absolute Deviation (MAD)	201.8403781
Skewness	0.1777879101
Sum	7993405
Variance	55261.55736

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 1. 9. 10.5 11.5 12.5 ... 876.5 879.5 884.5 885.5 893. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
188	2723	13.4%
534	2064	10.2%
433	1257	6.2%
38	643	3.2%
822	490	2.4%
305	400	2.0%
610	304	1.5%
450	284	1.4%
282	279	1.4%
12	275	1.4%
Other values (842)	11560	57.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	< 0.1%
3	1	< 0.1%
4	4	< 0.1%
6	4	< 0.1%
7	3	< 0.1%

Value	Count	Frequency (%)
893	3	< 0.1%
892	2	< 0.1%
891	1	< 0.1%
890	5	< 0.1%
889	7	< 0.1%

gift_cluster
Real number (ℝ_≥0)

ZEROS

Distinct count	5414
Unique (%)	26.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3303.358548
Minimum	0
Maximum	7567
Zeros	3568
Zeros (%)	17.6%
Memory size	158.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	587
median	3231
Q3	5787
95-th percentile	7213
Maximum	7567
Range	7567
Interquartile range (IQR)	5200

Descriptive statistics

Standard deviation	2541.082549
Coefficient of variation (CV)	0.7692421249
Kurtosis	-1.350521372
Mean	3303.358548
Median Absolute Deviation (MAD)	2210.610126
Skewness	0.1211027051
Sum	66988808
Variance	6457100.52

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 4.6500e+01 7.1500e+01 7.4500e+01 ... 7.4835e+03 7.5135e+03 7.5385e+03 7.5665e+03 7.5670e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	3568	17.6%
6489	60	0.3%
3371	59	0.3%
260	57	0.3%
6490	53	0.3%
6936	53	0.3%
6935	53	0.3%
2693	53	0.3%
2694	52	0.3%
2695	51	0.3%
Other values (5404)	16220	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3568	17.6%
1	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
7567	8	< 0.1%
7566	1	< 0.1%
7565	1	< 0.1%
7564	4	< 0.1%
7563	2	< 0.1%

instock_date
Categorical

HIGH CARDINALITY
TYPE DATE
UNIFORM

Distinct count	17147
Unique (%)	84.6%
Missing	0
Missing (%)	0.0%
Memory size	158.6 KiB

2015-09-25 13:22:53.000	7
2015-09-22 14:30:05.000	7
2015-05-06 17:20:59.000	7
2015-05-05 14:09:22.000	7
2016-03-29 21:55:43.000	7
Other values (17142)	20244

Value	Count	Frequency (%)
2015-09-25 13:22:53.000	7	< 0.1%
2015-09-22 14:30:05.000	7	< 0.1%
2015-05-06 17:20:59.000	7	< 0.1%
2015-05-05 14:09:22.000	7	< 0.1%
2016-03-29 21:55:43.000	7	< 0.1%
2015-09-22 15:24:59.000	6	< 0.1%
2015-08-21 21:36:19.000	6	< 0.1%
2016-03-29 22:54:54.000	6	< 0.1%
2015-08-22 19:36:19.000	6	< 0.1%
2015-05-09 13:10:20.000	6	< 0.1%
Other values (17137)	20214	99.7%

Length

Max length	23
Mean length	23
Min length	23

Value	Count	Frequency (%)
Decimal_Number	10	71.4%
Other_Punctuation	2	14.3%
Space_Separator	1	7.1%
Dash_Punctuation	1	7.1%

Value	Count	Frequency (%)
Common	14	100.0%

Value	Count	Frequency (%)
ASCII	14	100.0%

stock_update_date
Categorical

HIGH CARDINALITY
TYPE DATE
UNIFORM

Distinct count	14794
Unique (%)	73.0%
Missing	0
Missing (%)	0.0%
Memory size	158.6 KiB

2017-03-12 18:39:44.000	17
2017-03-12 20:39:44.000	14
2017-03-11 17:39:44.000	14
2017-04-02 15:42:25.000	13
2017-03-12 16:39:44.000	13
Other values (14789)	20208

Value	Count	Frequency (%)
2017-03-12 18:39:44.000	17	0.1%
2017-03-12 20:39:44.000	14	0.1%
2017-03-11 17:39:44.000	14	0.1%
2017-04-02 15:42:25.000	13	0.1%
2017-03-12 16:39:44.000	13	0.1%
2017-03-12 19:39:44.000	12	0.1%
2017-04-03 15:42:26.000	11	0.1%
2017-03-07 20:37:24.000	11	0.1%
2017-03-12 18:41:37.000	11	0.1%
2017-03-11 16:39:44.000	11	0.1%
Other values (14784)	20152	99.4%

Length

Max length	23
Mean length	23
Min length	23

Value	Count	Frequency (%)
Decimal_Number	10	71.4%
Other_Punctuation	2	14.3%
Space_Separator	1	7.1%
Dash_Punctuation	1	7.1%

Value	Count	Frequency (%)
Common	14	100.0%

Value	Count	Frequency (%)
ASCII	14	100.0%

lsg_1
Real number (ℝ_≥0)

Distinct count	7464
Unique (%)	36.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5314.595345
Minimum	0
Maximum	9979
Zeros	1
Zeros (%)	< 0.1%
Memory size	158.6 KiB

Quantile statistics

Minimum	0
5-th percentile	676.9
Q1	3311
median	5520
Q3	7535
95-th percentile	9432
Maximum	9979
Range	9979
Interquartile range (IQR)	4224

Descriptive statistics

Standard deviation	2703.317282
Coefficient of variation (CV)	0.5086590994
Kurtosis	-1.00388407
Mean	5314.595345
Median Absolute Deviation (MAD)	2283.403914
Skewness	-0.1493298783
Sum	107774679
Variance	7307924.325

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 968. 1017.5 1114.5 1714.5 ... 9620. 9622.5 9656. 9675.5 9979. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
8604	79	0.4%
9432	60	0.3%
6977	59	0.3%
5543	57	0.3%
7529	54	0.3%
9433	53	0.3%
6980	53	0.3%
5574	53	0.3%
6988	53	0.3%
5577	52	0.3%
Other values (7454)	19706	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	4	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	7	< 0.1%

Value	Count	Frequency (%)
9979	1	< 0.1%
9978	1	< 0.1%
9977	2	< 0.1%
9976	2	< 0.1%
9975	2	< 0.1%

lsg_2
Real number (ℝ_≥0)

Distinct count	5310
Unique (%)	26.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4187.653928
Minimum	0
Maximum	7604
Zeros	1
Zeros (%)	< 0.1%
Memory size	158.6 KiB

Quantile statistics

Minimum	0
5-th percentile	576
Q1	2251
median	4246
Q3	6504.5
95-th percentile	7205
Maximum	7604
Range	7604
Interquartile range (IQR)	4253.5

Descriptive statistics

Standard deviation	2274.875522
Coefficient of variation (CV)	0.5432338873
Kurtosis	-1.354571927
Mean	4187.653928
Median Absolute Deviation (MAD)	2028.057086
Skewness	-0.1343378906
Sum	84921434
Variance	5175058.64

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 30.5 156. 157.5 188.5 ... 7392.5 7482.5 7484.5 7486.5 7604. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
6883	2037	10.0%
2250	223	1.1%
4404	130	0.6%
915	79	0.4%
7186	60	0.3%
7103	59	0.3%
6408	57	0.3%
2872	54	0.3%
7172	53	0.3%
7205	53	0.3%
Other values (5300)	17474	86.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
3	3	< 0.1%
6	2	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
7604	2	< 0.1%
7603	1	< 0.1%
7602	1	< 0.1%
7601	1	< 0.1%
7600	3	< 0.1%

lsg_3
Real number (ℝ_≥0)

Distinct count	7032
Unique (%)	34.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4866.94551
Minimum	0
Maximum	9493
Zeros	1
Zeros (%)	< 0.1%
Memory size	158.6 KiB

Quantile statistics

Minimum	0
5-th percentile	653
Q1	2548
median	4839
Q3	7387
95-th percentile	8879
Maximum	9493
Range	9493
Interquartile range (IQR)	4839

Descriptive statistics

Standard deviation	2713.856392
Coefficient of variation (CV)	0.5576097753
Kurtosis	-1.252581449
Mean	4866.94551
Median Absolute Deviation (MAD)	2375.241978
Skewness	-0.02108544396
Sum	98696788
Variance	7365016.517

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 395.5 396.5 415. 436.5 ... 9427.5 9428.5 9439.5 9440.5 9493. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
7995	130	0.6%
7114	79	0.4%
8539	60	0.3%
8528	59	0.3%
3541	57	0.3%
5777	54	0.3%
3540	53	0.3%
8541	53	0.3%
8545	53	0.3%
8540	53	0.3%
Other values (7022)	19628	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	3	< 0.1%

Value	Count	Frequency (%)
9493	2	< 0.1%
9492	1	< 0.1%
9491	2	< 0.1%
9490	2	< 0.1%
9489	2	< 0.1%

lsg_4
Real number (ℝ_≥0)

Distinct count	1269
Unique (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1679.152226
Minimum	3
Maximum	2056
Zeros	0
Zeros (%)	0.0%
Memory size	158.6 KiB

Quantile statistics

Minimum	3
5-th percentile	406
Q1	1801
median	1912
Q3	1912
95-th percentile	1912
Maximum	2056
Range	2053
Interquartile range (IQR)	111

Descriptive statistics

Standard deviation	485.699119
Coefficient of variation (CV)	0.2892525832
Kurtosis	2.474228067
Mean	1679.152226
Median Absolute Deviation (MAD)	349.439593
Skewness	-2.000614206
Sum	34051528
Variance	235903.6342

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 3. 4. 109. 115.5 193. ... 1973.5 1990. 2031. 2034. 2056. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1912	13076	64.5%
406	533	2.6%
1873	233	1.1%
1887	132	0.7%
1845	125	0.6%
1816	120	0.6%
1786	118	0.6%
1859	110	0.5%
1705	107	0.5%
591	89	0.4%
Other values (1259)	5636	27.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	8	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
11	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
2056	1	< 0.1%
2055	1	< 0.1%
2054	1	< 0.1%
2053	1	< 0.1%
2052	1	< 0.1%

lsg_5
Real number (ℝ_≥0)

Distinct count	11
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.652694906
Minimum	0
Maximum	10
Zeros	3
Zeros (%)	< 0.1%
Memory size	158.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	9
Q3	10
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.34938795
Coefficient of variation (CV)	0.2715209511
Kurtosis	5.437682115
Mean	8.652694906
Median Absolute Deviation (MAD)	1.366414041
Skewness	-2.6002019
Sum	175468
Variance	5.519623741

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 1.5 2.5 3.5 4.5 ... 6.5 7.5 8.5 9.5 10. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
9	10390	51.2%
10	7605	37.5%
1	1369	6.8%
3	404	2.0%
8	247	1.2%
6	127	0.6%
4	105	0.5%
7	15	0.1%
5	12	0.1%
0	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	1369	6.8%
2	2	< 0.1%
3	404	2.0%
4	105	0.5%

Value	Count	Frequency (%)
10	7605	37.5%
9	10390	51.2%
8	247	1.2%
7	15	0.1%
6	127	0.6%

lsg_6
Real number (ℝ_≥0)

Distinct count	1583
Unique (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1265.898171
Minimum	0
Maximum	2065
Zeros	1
Zeros (%)	< 0.1%
Memory size	158.6 KiB

Quantile statistics

Minimum	0
5-th percentile	150
Q1	577.5
median	1616
Q3	1899
95-th percentile	1913
Maximum	2065
Range	2065
Interquartile range (IQR)	1321.5

Descriptive statistics

Standard deviation	697.8384954
Coefficient of variation (CV)	0.5512595813
Kurtosis	-1.379955601
Mean	1265.898171
Median Absolute Deviation (MAD)	635.0477428
Skewness	-0.5218620285
Sum	25671149
Variance	486978.5657

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 34.5 36.5 62.5 63.5 ... 2021.5 2022.5 2037.5 2038.5 2065. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1899	7276	35.9%
150	2065	10.2%
1913	566	2.8%
921	461	2.3%
746	337	1.7%
1778	302	1.5%
1689	243	1.2%
1266	192	0.9%
1616	188	0.9%
63	183	0.9%
Other values (1573)	8466	41.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	2	< 0.1%
2	2	< 0.1%
3	1	< 0.1%
4	2	< 0.1%

Value	Count	Frequency (%)
2065	1	< 0.1%
2064	3	< 0.1%
2063	1	< 0.1%
2062	1	< 0.1%
2059	1	< 0.1%

uk_date1
Categorical

HIGH CARDINALITY
TYPE DATE
UNIFORM

Distinct count	16384
Unique (%)	80.8%
Missing	0
Missing (%)	0.0%
Memory size	158.6 KiB

2017-03-31 12:40:24.000	17
2017-03-30 12:40:24.000	14
2017-04-02 14:40:24.000	14
2017-03-29 12:40:24.000	13
2017-04-01 16:40:28.000	13
Other values (16379)	20208

Value	Count	Frequency (%)
2017-03-31 12:40:24.000	17	0.1%
2017-03-30 12:40:24.000	14	0.1%
2017-04-02 14:40:24.000	14	0.1%
2017-03-29 12:40:24.000	13	0.1%
2017-04-01 16:40:28.000	13	0.1%
2017-03-29 12:42:20.000	13	0.1%
2017-04-02 16:40:25.000	12	0.1%
2017-03-29 16:40:24.000	12	0.1%
2017-03-31 14:40:24.000	12	0.1%
2017-04-02 12:40:28.000	12	0.1%
Other values (16374)	20147	99.3%

Length

Max length	23
Mean length	23
Min length	23

Value	Count	Frequency (%)
Decimal_Number	10	71.4%
Other_Punctuation	2	14.3%
Space_Separator	1	7.1%
Dash_Punctuation	1	7.1%

Value	Count	Frequency (%)
Common	14	100.0%

Value	Count	Frequency (%)
ASCII	14	100.0%

uk_date2
Categorical

HIGH CARDINALITY
TYPE DATE

Distinct count	7210
Unique (%)	35.6%
Missing	0
Missing (%)	0.0%
Memory size	158.6 KiB

2016-11-04 02:00:00.000	97
2016-11-05 02:00:00.000	96
2016-11-05 05:00:00.000	89
2016-11-04 03:00:00.000	88
2016-11-05 04:00:00.000	87
Other values (7205)	19822

Value	Count	Frequency (%)
2016-11-04 02:00:00.000	97	0.5%
2016-11-05 02:00:00.000	96	0.5%
2016-11-05 05:00:00.000	89	0.4%
2016-11-04 03:00:00.000	88	0.4%
2016-11-05 04:00:00.000	87	0.4%
2016-11-04 05:00:00.000	82	0.4%
2016-11-04 01:00:00.000	82	0.4%
2016-11-04 04:00:00.000	81	0.4%
2016-11-05 01:00:00.000	80	0.4%
2016-11-03 04:00:00.000	79	0.4%
Other values (7200)	19418	95.8%

Length

Max length	23
Mean length	23
Min length	23

Value	Count	Frequency (%)
Decimal_Number	10	71.4%
Other_Punctuation	2	14.3%
Space_Separator	1	7.1%
Dash_Punctuation	1	7.1%

Value	Count	Frequency (%)
Common	14	100.0%

Value	Count	Frequency (%)
ASCII	14	100.0%

is_discounted
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	158.6 KiB

0	15622
1	4657

Frequency Table

Value	Count	Frequency (%)
0	15622	77.0%
1	4657	23.0%

volumes
Real number (ℝ_≥0)

MISSING

Distinct count	25
Unique (%)	0.3%
Missing	12956
Missing (%)	63.9%
Infinite	0
Infinite (%)	0.0%

Mean	15.51536256
Minimum	5
Maximum	29
Zeros	0
Zeros (%)	0.0%
Memory size	158.6 KiB

Quantile statistics

Minimum	5
5-th percentile	6
Q1	9
median	13
Q3	24
95-th percentile	28
Maximum	29
Range	24
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	7.579669015
Coefficient of variation (CV)	0.4885267094
Kurtosis	-1.386066273
Mean	15.51536256
Median Absolute Deviation (MAD)	6.841471509
Skewness	0.3927800415
Sum	113619
Variance	57.45138237

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	730	3.6%
9	705	3.5%
8	601	3.0%
7	542	2.7%
6	413	2.0%
25	410	2.0%
27	383	1.9%
26	366	1.8%
11	358	1.8%
28	299	1.5%
Other values (15)	2516	12.4%
(Missing)	12956	63.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	18	0.1%
6	413	2.0%
7	542	2.7%
8	601	3.0%
9	705	3.5%

Value	Count	Frequency (%)
29	134	0.7%
28	299	1.5%
27	383	1.9%
26	366	1.8%
25	410	2.0%

price
Real number (ℝ_≥0)

Distinct count	12959
Unique (%)	63.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	143.4044115
Minimum	0.01
Maximum	7010.27
Zeros	0
Zeros (%)	0.0%
Memory size	158.6 KiB

Quantile statistics

Minimum	0.01
5-th percentile	17.3
Q1	45.645
median	75.6
Q3	126.845
95-th percentile	522.848
Maximum	7010.27
Range	7010.26
Interquartile range (IQR)	81.2

Descriptive statistics

Standard deviation	267.2811593
Coefficient of variation (CV)	1.863828014
Kurtosis	84.11998212
Mean	143.4044115
Median Absolute Deviation (MAD)	122.8924222
Skewness	6.732911599
Sum	2908098.06
Variance	71439.21814

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.000000e-02 1.255000e+00 1.505000e+00 2.505000e+00 5.055000e+00 ... 1.222500e+03 1.541600e+03 1.930330e+03 2.168745e+03 7.010270e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
69.59	8	< 0.1%
46.25	8	< 0.1%
51	8	< 0.1%
50.49	8	< 0.1%
59.01	8	< 0.1%
32.74	7	< 0.1%
43.01	7	< 0.1%
45.92	7	< 0.1%
41.81	7	< 0.1%
69.37	7	< 0.1%
Other values (12949)	20204	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	1	< 0.1%
1.25	1	< 0.1%
1.26	1	< 0.1%
1.28	1	< 0.1%
1.3	1	< 0.1%

Value	Count	Frequency (%)
7010.27	1	< 0.1%
6189.67	1	< 0.1%
5619.61	1	< 0.1%
5460.49	1	< 0.1%
4903.18	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

First rows

	gift_id	gift_type	gift_category	gift_cluster	instock_date	stock_update_date	lsg_1	lsg_2	lsg_3	lsg_4	lsg_5	lsg_6	uk_date1	uk_date2	is_discounted	volumes	price
0	GF_11156	61	534	3942	2014-02-21 05:07:06.000	2016-11-09 15:49:51.000	3377	5221	504	1912	10	554	2014-02-24 08:07:06.000	2014-02-24 07:07:06.000	0	NaN	175.54
1	GF_11157	61	534	3942	2014-02-21 06:07:06.000	2016-11-11 13:49:51.000	3377	5221	504	1912	10	554	2014-02-22 07:07:06.000	2014-02-24 06:07:06.000	1	NaN	95.80
2	GF_15689	584	262	0	2014-02-21 09:30:21.000	2016-03-24 14:46:18.000	5290	1579	3203	1912	9	1578	2016-01-26 00:04:45.000	2016-03-18 02:00:00.000	1	NaN	107.35
3	GF_11155	61	534	3942	2014-02-22 05:07:06.000	2016-11-10 16:49:51.000	3377	5221	504	1912	10	554	2016-11-07 13:49:51.000	2016-11-06 04:00:00.000	0	NaN	172.90
4	GF_11158	61	534	3942	2014-02-22 07:07:06.000	2016-11-10 13:49:51.000	3377	5221	504	1912	9	554	2016-11-07 15:49:51.000	2016-11-06 01:00:00.000	1	NaN	77.72
5	GF_15686	584	262	0	2014-02-23 07:30:21.000	2016-03-23 15:46:18.000	5290	1579	3203	1912	9	1578	2014-02-25 07:30:21.000	2014-02-24 08:30:21.000	1	NaN	142.84
6	GF_15690	584	262	0	2014-02-23 10:30:21.000	2016-03-23 18:46:18.000	5290	1579	3203	1912	9	1578	2016-01-25 02:04:45.000	2016-03-16 02:00:00.000	1	NaN	78.71
7	GF_15685	584	262	0	2014-02-24 10:30:21.000	2016-03-24 17:46:18.000	5290	1579	3203	1912	9	1578	2016-01-22 03:04:45.000	2016-03-17 03:00:00.000	0	NaN	166.81
8	GF_11159	61	534	3942	2014-02-25 07:07:06.000	2016-11-10 14:49:51.000	3377	5221	504	1912	10	554	2016-11-07 16:49:51.000	2015-04-08 12:48:27.025	0	NaN	72.72
9	GF_15688	584	262	0	2014-02-25 08:30:21.000	2016-03-24 16:46:18.000	5290	1579	3203	1912	9	1578	2016-01-23 03:04:45.000	2016-03-11 04:00:00.000	1	NaN	107.12

Last rows

	gift_id	gift_type	gift_category	gift_cluster	instock_date	stock_update_date	lsg_1	lsg_2	lsg_3	lsg_4	lsg_5	lsg_6	uk_date1	uk_date2	is_discounted	volumes	price
20269	GF_23985	415	188	4256	2016-11-12 13:17:55.000	2016-11-16 12:50:47.000	21	5845	2438	1912	10	150	2016-11-16 12:50:47.000	2016-10-30 02:00:00.000	1	NaN	37.31
20270	GF_9030	1173	534	4261	2016-11-12 13:17:57.000	2016-11-15 11:17:57.000	600	163	6710	1912	10	1899	2016-11-13 12:17:57.000	2016-11-03 03:00:00.000	1	NaN	35.61
20271	GF_22761	1262	433	5487	2016-11-12 13:18:10.000	2016-11-17 11:18:10.000	1491	6883	2870	1912	10	921	2016-11-11 14:18:10.000	2016-11-04 05:00:00.000	1	NaN	36.26
20272	GF_13772	531	433	5980	2016-11-12 13:23:35.000	2016-11-15 13:23:35.000	5056	5490	2954	1912	10	2038	2016-11-15 14:23:35.000	2016-11-13 13:23:35.000	1	NaN	24.71
20273	GF_10352	1262	433	42	2016-11-12 13:26:09.000	2016-11-17 11:26:09.000	1480	6883	3747	1912	10	1899	2016-11-12 14:26:09.000	2016-11-10 03:00:00.000	1	NaN	22.02
20274	GF_10269	105	704	6448	2016-11-12 13:46:42.000	2016-11-17 10:46:42.000	2055	6883	995	1912	10	1899	2016-11-14 14:46:42.000	2016-11-11 03:00:00.000	0	NaN	57.68
20275	GF_5854	1220	526	817	2016-11-12 13:46:47.000	2016-11-18 13:46:47.000	8323	6753	6706	1912	10	1899	2016-11-13 10:46:47.000	2016-10-28 02:00:00.000	0	NaN	122.87
20276	GF_563	509	705	821	2016-11-12 13:46:57.000	2017-01-21 19:30:04.000	2826	4009	2912	1912	10	1451	2017-01-21 18:30:04.000	2017-01-18 01:00:00.000	0	NaN	47.14
20277	GF_9107	682	213	5620	2016-11-12 13:47:01.000	2016-11-18 11:47:01.000	2089	6883	3607	1912	10	822	2016-11-14 12:47:01.000	2016-11-13 02:00:00.000	0	NaN	47.68
20278	GF_5683	1061	212	4987	2016-11-12 13:48:30.000	2016-11-18 12:48:30.000	898	1814	6109	1912	10	1899	2016-11-12 10:48:30.000	2016-11-10 02:00:00.000	0	NaN	52.81

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Missing values

Sample

First rows

Last rows